sql=[
'''
CREATE TABLE "kv" (
"k"  TEXT NOT NULL,
"v"  TEXT,
PRIMARY KEY ("k")
);

'''   

,'''
CREATE TABLE "teacher_list" (
"name"  TEXT NOT NULL,
"status"  INTEGER,
"session_count"  INTEGER,
"weight"  REAL,
PRIMARY KEY ("name")
);
''' 
,'''
CREATE TABLE "exam_list" (
"ID"  INTEGER NOT NULL,
"title"  TEXT NOT NULL,
"sessionNum"  INTEGER,
"teacherNum"  INTEGER,
"roomNum"  INTEGER,
PRIMARY KEY ("ID" ASC)
);
'''

,'''
CREATE TABLE "temp_teacher_input" (
"name"  TEXT NOT NULL,
"status"  INTEGER,
PRIMARY KEY ("name" ASC)
);
'''
,'''
CREATE TABLE "exam_info" (
"examID"  INTEGER NOT NULL,
"session"  INTEGER NOT NULL,
"title"  TEXT,
"session_date"  TEXT,
"start_time"  TEXT,
"end_time"  TEXT,
"confilct_week"  TEXT,
"confilct_class_time"  TEXT,
"confilct_class_name"  TEXT,
PRIMARY KEY ("examID" ASC, "session")
);
'''

,'''
CREATE TABLE "session_info" (
"examID"  INTEGER NOT NULL,
"session"  INTEGER NOT NULL,
"room"  INTEGER NOT NULL,
"sort"  INTEGER NOT NULL,
"name"  TEXT
);
'''
]